/*
 Navicat Premium Data Transfer

 Source Server         : local
 Source Server Type    : MySQL
 Source Server Version : 80020
 Source Host           : localhost:3306
 Source Schema         : springboot-demo

 Target Server Type    : MySQL
 Target Server Version : 80020
 File Encoding         : 65001

 Date: 11/01/2022 10:24:57
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for shiro_menu
-- ----------------------------
DROP TABLE IF EXISTS `shiro_menu`;
CREATE TABLE `shiro_menu` (
  `mid` bigint NOT NULL COMMENT '主键ID',
  `menu_name` varchar(100) DEFAULT NULL COMMENT '菜单名称',
  `menu_parent_id` bigint DEFAULT NULL COMMENT '上级菜单ID',
  `menu_sort` int DEFAULT NULL COMMENT '展示顺序',
  `menu_level` varchar(1) DEFAULT NULL COMMENT '菜单级别',
  `status` varchar(1) DEFAULT NULL COMMENT '菜单状态,0为无效，1为有效',
  `menu_path` varchar(500) DEFAULT NULL COMMENT '菜单路径',
  `menu_control` varchar(1) DEFAULT NULL COMMENT '是否需要权限控制',
  `menu_des` varchar(500) DEFAULT NULL COMMENT '菜单备注',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  `update_date` datetime DEFAULT NULL COMMENT '修改时间',
  `modify_user` varchar(50) DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`mid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of shiro_menu
-- ----------------------------
BEGIN;
INSERT INTO `shiro_menu` VALUES (1, '报表服务', 0, 1, '1', '1', NULL, NULL, '报表服务', '2022-01-11 10:20:58', '2022-01-11 10:21:00', 'admin');
INSERT INTO `shiro_menu` VALUES (2, '报表优化情况', 1, 1, '2', '1', 'https://www.baidu.com/', NULL, '报表优化情况', '2022-01-11 10:22:22', '2022-01-11 10:22:25', 'admin');
INSERT INTO `shiro_menu` VALUES (3, '填报用例', 1, 2, '2', '1', 'http://www.hao123.com', NULL, '填报用例', '2022-01-11 10:23:10', '2022-01-11 10:23:13', 'admin');
COMMIT;

-- ----------------------------
-- Table structure for shiro_role
-- ----------------------------
DROP TABLE IF EXISTS `shiro_role`;
CREATE TABLE `shiro_role` (
  `rid` bigint NOT NULL COMMENT '角色ID',
  `role_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '角色名',
  `status` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '角色状态,0为无效，1为有效',
  `role_des` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '角色备注',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  `update_date` datetime DEFAULT NULL COMMENT '修改时间',
  `modify_user` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '修改人',
  PRIMARY KEY (`rid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of shiro_role
-- ----------------------------
BEGIN;
INSERT INTO `shiro_role` VALUES (1, '管理员', '1', '管理员', '2022-01-11 10:17:33', '2022-01-11 10:17:36', 'admin');
INSERT INTO `shiro_role` VALUES (2, '普通用户', '1', '普通用户', '2022-01-11 10:17:59', '2022-01-11 10:18:02', 'admin');
COMMIT;

-- ----------------------------
-- Table structure for shiro_role_menu_ref
-- ----------------------------
DROP TABLE IF EXISTS `shiro_role_menu_ref`;
CREATE TABLE `shiro_role_menu_ref` (
  `id` bigint NOT NULL,
  `role_id` bigint NOT NULL,
  `menu_id` bigint NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of shiro_role_menu_ref
-- ----------------------------
BEGIN;
INSERT INTO `shiro_role_menu_ref` VALUES (1, 1, 1);
INSERT INTO `shiro_role_menu_ref` VALUES (2, 1, 2);
INSERT INTO `shiro_role_menu_ref` VALUES (3, 2, 3);
COMMIT;

-- ----------------------------
-- Table structure for shiro_role_user_ref
-- ----------------------------
DROP TABLE IF EXISTS `shiro_role_user_ref`;
CREATE TABLE `shiro_role_user_ref` (
  `id` bigint NOT NULL,
  `role_id` bigint NOT NULL,
  `user_id` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of shiro_role_user_ref
-- ----------------------------
BEGIN;
INSERT INTO `shiro_role_user_ref` VALUES (1, 1, '1');
INSERT INTO `shiro_role_user_ref` VALUES (2, 2, '3');
COMMIT;

-- ----------------------------
-- Table structure for shiro_user
-- ----------------------------
DROP TABLE IF EXISTS `shiro_user`;
CREATE TABLE `shiro_user` (
  `id` bigint NOT NULL,
  `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '邮箱',
  `login_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '登录账号',
  `pass_word` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '密码',
  `user_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '用户名称',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of shiro_user
-- ----------------------------
BEGIN;
INSERT INTO `shiro_user` VALUES (1, '782006625@qq.com', 'admin', '123456', '管理员', '2022-01-11 10:16:13');
INSERT INTO `shiro_user` VALUES (3, '782006625@qq.com', 'vicente', '123456', '森林', '2022-01-11 10:18:45');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
